|_|_|_|_|_|_|_|_|_|_|_|_|_|_|_|_|_|_|_|_|_|_|_|_|_|_|_|_|_|_|_|_|_|_|_|_|_|_|_|_|

SSW Monthly Newsletter

This months newsletter sponsored by

Pinnacle Publishing Inc.

www.pinpub.com

Leading provider of newsletters and information products

SQL Server Professional www.pinpub.com/sqlpro

Smart Access www.smartaccessnewsletter.com

|_|_|_|_|_|_|_|_|_|_|_|_|_|_|_|_|_|_|_|_|_|_|_|_|_|_|_|_|_|_|_|_|_|_|_|_|_|_|_|_|

G’day all friends and clients of SSW!

This Month...

1. THE ACCESS/ASP/SQL SERVER USERS GROUP SYDNEY, WEDNESDAY 17th MAY
- The English Query
- Optimising Data with ADO

3. GREAT DEVELOPER TOOLS – DATA PRO!

3. HOT TIPS FOR DEVELOPERS

4. WANT TO WORK ON SQL SERVER 2000? - WORK AT SSW

5. FOR LET - OFFICE SPACE IN NEUTRAL BAY. IDEAL FOR DEVELOPER

============================================================================
1. The Access/ASP/SQL Server Users Group Sponsored by Microsoft and Superior Software for Windows
Wednesday 17th May 2000, 5:45 pm

www.ssw.com.au/accessUG
============================================================================

Are you an Access/SQL Server/ASP developer looking for hot tips, inside
information and great contacts?

Then come along to your Users Group at the Microsoft Building at North Ryde!

Did you miss the SQL Server 2000 conference this month? It was a sold out event that indicates how big the SQL Server Developer community is getting.

We have two of the sessions presented again at the Users' Group.

- Topics in English Query development Russell Darroch www.accord-it.com.au (ACT)

- Optisimising Data with ADO Adam Cogan www.ssw.com.au (Sydney)

This is the first time we have covered Engish Query at the User Group and should give you plenty of ideas.

The English Query

The English Query is a very rich third-generation product with many features that are relevant to developers as you build more advanced interfaces and perfect your English Query models. Question Builder is a new component of English Query that lets you expose the entities and relationships in your English Query model in graphical form in your application or Web page. Question Builder lets the users build questions and executes queries by dragging entities onto a graphical pane and clicking relationship icons. English Query also has the capibility of executing commands that the user has provided (eg "buy me 10 of the cheapest Aussie cookbooks"). You will see a demo of a number of other features as well

==========================================================================
2. Great Developer Tools for Access 97 or 2000 - SSW Data PRO!
==========================================================================

Does this sound familiar?

You have a new version of a database ready for your client ..... "Oh no, now I'll have to find out the new tables, fields and relationships I added. I'll have to get the clients copy of the data so I can do the changes. I Hope I haven't forgotten any of the changes. Gee what was that field I renamed????"

With SSW Data PRO!, When your client gets the new version of your database, it will detect that the data structure needs revisions and performs the revisions automatically!

It's that simple!

Here's what Jeff Stubbert of MarinaSoft Software said:

"I bought DataPro 97 from you a few months ago and didn't have a need to use
it at the time but I wanted to include it in my database for future
upgrades.

"It has been a lifesaver! I just finished making 93 changes to the data
structure of my backend database including adding and deleting tables,
fields,executing sql statements and running queries. Worked like a charm!

"Just wanted to say thanks..."

Jeff Stubbert
MarinaSoft Software

Visit SSW Data PRO! web site at www.ssw.com.au/DataPRO

=========================================================================
3. Hot Tips for Developers
=========================================================================

To do efficient ADO code you seem to have to do a lot of code.
Did you know that ADO loves stored procedures. You can use the connection object to open a query.

You can do it this way...

Dim cn As ADODB.Connection
Dim cmd As ADODB.Command
Dim rs As ADODB.Recordset
Dim params As ADODB.Parameters
Dim param As ADODB.Parameter

' Create connection and command objects
Set cn = New ADODB.Connection
Set cmd = New ADODB.Command

' Set connection properties and open
cn.ConnectionString = "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Initial Catalog=Northwind;Data Source=GOOSSE"
cn.CursorLocation = adUseClient
cn.Open

' Set command properties
With cmd
Set .ActiveConnection = cn
.CommandText = "SalesbyYear"
.CommandType = adCmdStoredProc
Set params = .Parameters
End With

' Define stored procedure params and append to command.
' params.Append cmd.CreateParameter("RETURN_VALUE", adInteger, adParamReturnValue, 0)
params.Append cmd.CreateParameter("@Beginning_Date", adDBTimeStamp, adParamInput, 0)
params.Append cmd.CreateParameter("@Ending_Date", adDBTimeStamp, adParamInput, 0)

' Specify input parameter values
params("@Beginning_Date") = "1/1/1990"
params("@Ending_Date") = "1/1/2000"

' Execute the command
Set rs = cmd.Execute

Set ctlGrid.DataSource = rs
Beep

Set rs = Nothing
Set params = Nothing
Set cn = Nothing

A LOT OF CODE RIGHT!!!

Alternatively you can do it this way and save a lot of time!!!

Dim cn As ADODB.Connection
Set cn = New ADODB.Connection

' Set connection properties and open
cn.ConnectionString = "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Initial Catalog=Northwind;Data Source=GOOSSE"
cn.CursorLocation = adUseClient
cn.Open

Dim rs As ADODB.Recordset
Set rs = New ADODB.Recordset

cn.SalesByYear "1/1/1990", "1/1/2000", rs

Set ctlGrid.DataSource = rs
Beep

Set rs = Nothing
Set cn = Nothing

Got a hot tip you want to share? Email 696e666f72407373772e636f6d2e6175

=========================================================================
4. Positions Vacant
=========================================================================

SSW is looking for a Senior Database Developer focussed on new technology who is keen to play a key role in the success of SSW.

- SQL Server 2000
- ASP
- COM+
- Stored Procedures

Must be articulate and dedicated to getting the job done. Attractive Salary will be negotiated
email 696e666f72407373772e636f6d2e6175
Phone 02 9953 3000
Fax 02 9953 3105

=========================================================================
5. For Let – Newly Refurbished Office Space
=========================================================================

Within the SSW offices there is newly furnished office available for let.

- Opposite The Oaks Hotel, Neutral Bay!
- It is fully furnished and partitioned and is ideal for two people
(approx. 20sqm)
- Excellent Northside Location
- Easy City Access (express bus or hop straight on the freeway – 20
minutes to airport)
- Air-conditioning
- All this for less than One thousand dollars a month!!!

If you are running a small business and are looking for a place to move,
email us: 696e666f72407373772e636f6d2e6175 and drop by to have a look.

========================================================================

SSW’s Marketing Team edits this newsletter. We would like your feedback.

If you have a tip you want to share, a website you want us to review or
comments on our service, please write to 696e666f72407373772e636f6d2e6175 or visit us at
www.ssw.com.au

SSW Pty Limited
Gateway Court, Suite 10, 81 - 91 Military Road, Neutral Bay, NSW,2089
Phone: +61 2 9953 3000 Fax: +61 2 9953 3105
www.ssw.com.au

SSW specialises in delivering efficient, cost effective
solutions for your database or Internet requirements. Our ability to
integrate these functions together helps companies streamline operations,
while making the most of opportunities presented by the on-line world.

If you can't use our services at the moment but know someone who may, pass
on our details.........it could earn you some easy $$$$! Superior
Software has a guaranteed $150 Spotters Fee for any referrals we convert
into new Database or Web Site development business.

We're not the people surfing the net, we're the people making the waves.
==========================================================================

You receive this newsletter as a client and friend of SSW
for Windows.

To unsubscribe from this newsletter: info@s*w.com.au
Powered by SSW Email Merge PRO!